package com.oa.srms.apps.dao.student;

import java.util.List;

import com.oa.srms.apps.entity.student.StudentDetailValue;
import com.oa.srms.apps.entity.student.StudentInfoValue;

public interface IStudentInfoDao {
	public Integer addStudentInfo(StudentInfoValue studentInfoValue) throws Exception;
	
	public void editStudentInfo(StudentInfoValue studentInfoValue) throws Exception;
	
	public StudentInfoValue queryById(Integer id) throws Exception;
	
	public StudentInfoValue queryByStuNo(String stuNo) throws Exception;
	
	public List<StudentInfoValue> queryStudentInfo(Integer states) throws Exception;
	
	public List<StudentInfoValue> queryStudentInfoForSendMail(Integer studentState, Integer mailState) throws Exception;
	
	public List<StudentInfoValue> queryStudentInfo(StudentDetailValue studentDetail) throws Exception;
	
	public List<StudentInfoValue> queryStudentInfo(String stuNo,String stuName,Integer states, StudentDetailValue studentDetail, Integer rows, Integer pageNo) throws Exception;

	public Integer getTotalPageNumber(String stuNo,String stuName, Integer states, StudentDetailValue studentDetail, Integer rows);
	
	public List<StudentInfoValue> queryStudentInfoAboveStates(String stuNo,String stuName,Integer states, StudentDetailValue studentDetail, Integer rows, Integer pageNo) throws Exception;

	public Integer getTotalPageNumberAboveStates(String stuNo,String stuName, Integer states, StudentDetailValue studentDetail, Integer rows);
	
	public Integer getTotalNumber();
}
